/****** Object:  Table [dbo].[forum_moderators]    Script Date: 09/27/2007 23:45:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[forum_moderators]
(
[forumid] [uniqueidentifier] NOT NULL,
[userid] [uniqueidentifier] NOT NULL
)
GO
/****** Object:  Table [dbo].[email_message]    Script Date: 09/27/2007 23:45:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[email_message](
	[msgid] [int] IDENTITY(1,1) NOT NULL,
	[emailmsg] [text] NOT NULL,
 CONSTRAINT [PK_email_message] PRIMARY KEY CLUSTERED 
(
	[msgid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[email_notes]    Script Date: 09/27/2007 23:45:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[email_notes](
	[emailid] [int] NOT NULL,
	[emailnotes] [text] NOT NULL,
 CONSTRAINT [PK_email_notes] PRIMARY KEY CLUSTERED 
(
	[emailid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[folders]    Script Date: 09/27/2007 23:45:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[folders](
	[nodeid] [uniqueidentifier] NOT NULL,
	[parentnodeid] [uniqueidentifier] NULL,
	[name] [varchar](max) NOT NULL,
	[createdate] [datetime] NOT NULL CONSTRAINT [DF_folders_createdate]  DEFAULT (getdate()),
	[archived] [tinyint] NULL CONSTRAINT [DF_folders_archived]  DEFAULT ((0)),
	[userid] [uniqueidentifier] NULL,
 CONSTRAINT [PK_folders] PRIMARY KEY CLUSTERED 
(
	[nodeid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[resources]    Script Date: 09/27/2007 23:47:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[resources](
	[resourceid] [uniqueidentifier] NOT NULL,
	[resourcename] [varchar](max) NOT NULL,
	[resourcesize] [int] NOT NULL,
	[resourcedesc] [varchar](max) NULL,
	[resourcetitle] [nvarchar](300) NULL,
	[contenttype] [varchar](max) NOT NULL,
	[resource] [image] NOT NULL,
	[thumbnail] [image] NULL,
	[archived] [tinyint] NULL CONSTRAINT [DF_resources_deleteresource]  DEFAULT ((0)),
	[createdate] [datetime] NOT NULL CONSTRAINT [DF_resources_createdate]  DEFAULT (getdate()),
	[private] [bit] NULL CONSTRAINT [DF_resources_private]  DEFAULT ((0)),
	[userid] [uniqueidentifier] NULL,
 CONSTRAINT [PK_resources] PRIMARY KEY CLUSTERED 
(
	[resourceid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[pollresults]    Script Date: 09/27/2007 23:46:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[pollresults](
	[PollId] [uniqueidentifier] NOT NULL,
	[PollChoice] [uniqueidentifier] NOT NULL,
	[userid] [uniqueidentifier] NOT NULL,
 CONSTRAINT [PK_PollResults] PRIMARY KEY CLUSTERED 
(
	[PollId] ASC,
	[userid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[item_categories]    Script Date: 09/27/2007 23:46:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[item_categories](
	[itemid] [uniqueidentifier] NOT NULL,
	[categoryid] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[aspnet_SchemaVersions]    Script Date: 09/27/2007 23:45:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aspnet_SchemaVersions](
	[Feature] [nvarchar](128) NOT NULL,
	[CompatibleSchemaVersion] [nvarchar](128) NOT NULL,
	[IsCurrentVersion] [bit] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Feature] ASC,
	[CompatibleSchemaVersion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[categories]    Script Date: 09/27/2007 23:45:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[categories](
	[categoryid] [uniqueidentifier] NOT NULL,
	[parentcategoryid] [uniqueidentifier] NULL,
	[name] [varchar](max) NOT NULL,
	[createdate] [datetime] NOT NULL,
	[archived] [tinyint] NULL CONSTRAINT [DF_categories_archived]  DEFAULT ((0)),
 CONSTRAINT [PK_categories] PRIMARY KEY CLUSTERED 
(
	[categoryid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[resources_folders]    Script Date: 09/27/2007 23:47:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[resources_folders](
	[resourceid] [uniqueidentifier] NOT NULL,
	[nodeid] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AspNet_SqlCacheTablesForChangeNotification]    Script Date: 09/27/2007 23:45:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AspNet_SqlCacheTablesForChangeNotification](
	[tableName] [nvarchar](450) NOT NULL,
	[notificationCreated] [datetime] NOT NULL DEFAULT (getdate()),
	[changeId] [int] NOT NULL DEFAULT ((0)),
PRIMARY KEY CLUSTERED 
(
	[tableName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[blog]    Script Date: 09/27/2007 23:45:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[blog](
	[blogid] [uniqueidentifier] NOT NULL,
	[title] [nvarchar](max) NOT NULL,
	[body] [nvarchar](max) NOT NULL,
	[userid] [uniqueidentifier] NOT NULL,
	[createdate] [datetime] NOT NULL,
	[private] [bit] NOT NULL,
 CONSTRAINT [PK_blog] PRIMARY KEY CLUSTERED 
(
	[blogid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[pollquestions]    Script Date: 09/27/2007 23:46:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[pollquestions](
	[PollId] [uniqueidentifier] NOT NULL,
	[PollQuestion] [varchar](max) NOT NULL,
	[ExpirationDate] [datetime] NULL,
	[UserID] [uniqueidentifier] NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[Closed] [bit] NOT NULL CONSTRAINT [DF_PollQuestions_Closed]  DEFAULT ((0)),
	[AnswerCount] [decimal](18, 0) NOT NULL CONSTRAINT [DF_PollQuestions_AnswerCount]  DEFAULT ((0)),
 CONSTRAINT [PK_PollQuestions] PRIMARY KEY CLUSTERED 
(
	[PollId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Ranks]    Script Date: 09/27/2007 23:47:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Ranks](
	[id] [uniqueidentifier] NOT NULL,
	[itemid] [uniqueidentifier] NOT NULL,
	[userid] [uniqueidentifier] NOT NULL,
	[rank] [int] NOT NULL CONSTRAINT [DF_Ranks_rank]  DEFAULT ((0)),
	[revision] [int] NULL CONSTRAINT [DF_Ranks_revision]  DEFAULT ((0)),
 CONSTRAINT [PK_Ranks] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[pollanswers]    Script Date: 09/27/2007 23:46:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[pollanswers](
	[PollId] [uniqueidentifier] NOT NULL,
	[AnswerId] [uniqueidentifier] NOT NULL,
	[AnswerText] [varchar](max) NOT NULL,
	[AnswerCount] [decimal](18, 0) NULL CONSTRAINT [DF_PollAnswers_AnswerCount]  DEFAULT ((0)),
 CONSTRAINT [PK_PollAnswers] PRIMARY KEY CLUSTERED 
(
	[AnswerId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[page_final_data]    Script Date: 09/27/2007 23:46:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[page_final_data](
	[id] [uniqueidentifier] NOT NULL CONSTRAINT [DF_article_final_data_id]  DEFAULT (newid()),
	[pageid] [uniqueidentifier] NOT NULL,
	[modifydate] [datetime] NOT NULL CONSTRAINT [DF_article_final_data_modifydate]  DEFAULT (getdate()),
	[placeholdernumber] [int] NOT NULL,
	[placeholderdata] [varchar](max) NULL,
	[lastuserid] [uniqueidentifier] NULL,
	[pagerevision] [int] NOT NULL,
 CONSTRAINT [PK_article_final_data_1] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[comments]    Script Date: 09/27/2007 23:45:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[comments](
	[id] [uniqueidentifier] NOT NULL,
	[parentid] [uniqueidentifier] NULL,
	[itemid] [uniqueidentifier] NOT NULL,
	[userid] [uniqueidentifier] NULL,
	[subject] [nvarchar](max) NULL,
	[comments] [nvarchar](max) NOT NULL,
	[createdate] [datetime] NOT NULL CONSTRAINT [DF_article_comments_createdate]  DEFAULT (getdate()),
	[archived] [bit] NULL CONSTRAINT [DF_page_comments_archived]  DEFAULT ((0)),
 CONSTRAINT [PK_article_comments] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[page_archive_data]    Script Date: 09/27/2007 23:46:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[page_archive_data](
	[id] [uniqueidentifier] NOT NULL CONSTRAINT [DF_article_archive_data_id]  DEFAULT (newid()),
	[pageid] [uniqueidentifier] NOT NULL,
	[modifydate] [datetime] NOT NULL CONSTRAINT [DF_article_archive_data_modifydate]  DEFAULT (getdate()),
	[placeholdernumber] [int] NOT NULL,
	[placeholderdata] [varchar](max) NULL,
	[lastuserid] [uniqueidentifier] NULL,
	[pagerevision] [int] NOT NULL,
 CONSTRAINT [PK_page_archive_data] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[usercontrols]    Script Date: 09/27/2007 23:47:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[usercontrols](
	[id] [uniqueidentifier] NOT NULL CONSTRAINT [DF_usercontrols_id]  DEFAULT (newid()),
	[controlid] [int] IDENTITY(1,1) NOT NULL,
	[displayname] [nvarchar](2000) NOT NULL,
	[controlpath] [nvarchar](4000) NOT NULL,
	[controlname] [nvarchar](4000) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[links]    Script Date: 09/27/2007 23:46:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[links](
	[linkid] [uniqueidentifier] NOT NULL,
	[linktitle] [nvarchar](max) NOT NULL,
	[linkurl] [nvarchar](max) NOT NULL,
	[linkdesc] [nvarchar](max) NULL,
	[userid] [uniqueidentifier] NOT NULL,
	[createdate] [datetime] NOT NULL,
 CONSTRAINT [PK_links] PRIMARY KEY CLUSTERED 
(
	[linkid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[page_working_data]    Script Date: 09/27/2007 23:46:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[page_working_data](
	[id] [uniqueidentifier] NOT NULL CONSTRAINT [DF_article_working_data_id]  DEFAULT (newid()),
	[pageid] [uniqueidentifier] NOT NULL,
	[placeholdernumber] [int] NOT NULL,
	[placeholderdata] [varchar](max) NULL,
	[lastuserid] [uniqueidentifier] NULL,
	[pagerevision] [int] NOT NULL,
 CONSTRAINT [PK_page_working_data] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[forum_board]    Script Date: 09/27/2007 23:45:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[forum_board](
	[BoardID] [uniqueidentifier] NOT NULL,
	[BoardName] [nvarchar](200) NOT NULL,
	[LastPostBy] [nvarchar](max) NULL,
	[LastUserID] [uniqueidentifier] NULL,
	[LastPostDate] [datetime] NULL,
	[SortOrder] [int] NULL,
 CONSTRAINT [PK_forum_board] PRIMARY KEY CLUSTERED 
(
	[BoardID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[int_value]    Script Date: 09/27/2007 23:46:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[int_value](
	[int_name] [nvarchar](2000) NOT NULL,
	[int_value] [int] NOT NULL,
	[longdesc] [nvarchar](4000) NOT NULL,
	[shortdesc] [nvarchar](2000) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SiteMap]    Script Date: 09/27/2007 23:47:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SiteMap](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [varchar](max) NULL,
	[Description] [varchar](max) NULL,
	[Url] [varchar](max) NULL,
	[Roles] [varchar](max) NULL,
	[Parent] [int] NULL,
 CONSTRAINT [PK_SiteMap] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[page_hits]    Script Date: 09/27/2007 23:46:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[page_hits](
	[id] [uniqueidentifier] NOT NULL,
	[pageid] [uniqueidentifier] NOT NULL,
	[userid] [uniqueidentifier] NULL,
	[userrank] [int] NOT NULL,
	[pagerevision] [int] NOT NULL CONSTRAINT [DF_article_hits_articlerevision]  DEFAULT ((0)),
	[views] [int] NOT NULL CONSTRAINT [DF_article_hits_views]  DEFAULT ((0)),
	[iv_access_type] [int] NOT NULL CONSTRAINT [DF_page_hits_iv_access_type]  DEFAULT ((0)),
	[createdate] [datetime] NOT NULL CONSTRAINT [DF_article_hits_createdate]  DEFAULT (getdate()),
 CONSTRAINT [PK_article_hits] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[aspnet_Applications]    Script Date: 09/27/2007 23:44:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aspnet_Applications](
	[ApplicationName] [nvarchar](256) NOT NULL,
	[LoweredApplicationName] [nvarchar](256) NOT NULL,
	[ApplicationId] [uniqueidentifier] NOT NULL DEFAULT (newid()),
	[Description] [nvarchar](256) NULL,
PRIMARY KEY NONCLUSTERED 
(
	[ApplicationId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED 
(
	[ApplicationName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED 
(
	[LoweredApplicationName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[templates]    Script Date: 09/27/2007 23:47:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[templates](
	[id] [uniqueidentifier] NOT NULL,
	[templateid] [uniqueidentifier] NOT NULL,
	[placeholdernumber] [int] NOT NULL CONSTRAINT [DF_templates_placeholdernumber]  DEFAULT ((0)),
	[fieldname] [nvarchar](50) NOT NULL,
	[fieldtype] [int] NULL,
	[fieldheight] [int] NOT NULL,
	[fieldwidth] [int] NOT NULL,
	[editortype] [int] NULL,
	[showname] [bit] NULL CONSTRAINT [DF_templates_showname]  DEFAULT ((1)),
 CONSTRAINT [PK_templates] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Views]    Script Date: 09/27/2007 23:47:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Views](
	[itemid] [uniqueidentifier] NOT NULL,
	[viewcount] [bigint] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[themes]    Script Date: 09/27/2007 23:47:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[themes](
	[themeid] [uniqueidentifier] NOT NULL CONSTRAINT [DF_themes_themeid]  DEFAULT (newid()),
	[themename] [nvarchar](max) NOT NULL,
	[themefolder] [nvarchar](max) NOT NULL,
	[usagecount] [int] NULL,
	[archived] [bit] NULL CONSTRAINT [DF_themes_archived]  DEFAULT ((0)),
 CONSTRAINT [PK_themes] PRIMARY KEY CLUSTERED 
(
	[themeid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DBVersion]    Script Date: 09/27/2007 23:45:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DBVersion](
	[version] [decimal](18, 2) NOT NULL,
	[installdate] [datetime] NOT NULL,
 CONSTRAINT [PK_DBVersion] PRIMARY KEY CLUSTERED 
(
	[version] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[page_summary]    Script Date: 09/27/2007 23:46:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[page_summary](
	[pageid] [uniqueidentifier] NOT NULL,
	[summary] [varchar](max) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[options]    Script Date: 09/27/2007 23:46:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[options](
	[OptionsID] [uniqueidentifier] NOT NULL,
	[ItemID] [uniqueidentifier] NOT NULL,
	[AllowSummary] [bit] NOT NULL CONSTRAINT [DF_Options_AllowSummary]  DEFAULT ((0)),
	[AllowComments] [bit] NOT NULL CONSTRAINT [DF_Options_AllowComments]  DEFAULT ((0)),
	[AllowTags] [bit] NOT NULL CONSTRAINT [DF_Options_AllowTags]  DEFAULT ((0)),
	[AllowSubscriptions] [bit] NOT NULL CONSTRAINT [DF_Options_AllowSubscriptions]  DEFAULT ((0)),
	[AllowRanking] [bit] NOT NULL CONSTRAINT [DF_Options_AllowRanking]  DEFAULT ((0)),
	[AllowInfoTools] [bit] NOT NULL CONSTRAINT [DF_Options_AllowInfoTools]  DEFAULT ((0)),
 CONSTRAINT [PK_Options] PRIMARY KEY CLUSTERED 
(
	[OptionsID] ASC,
	[ItemID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[tags]    Script Date: 09/27/2007 23:47:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tags](
	[tagid] [uniqueidentifier] NOT NULL,
	[userid] [uniqueidentifier] NOT NULL,
	[itemid] [uniqueidentifier] NOT NULL,
	[tagname] [nvarchar](max) NOT NULL,
	[archived] [bit] NULL CONSTRAINT [DF_tags_archived]  DEFAULT ((0)),
	[iv_tagtype] [int] NULL CONSTRAINT [DF_tags_tagtype]  DEFAULT ((0)),
 CONSTRAINT [PK_tags] PRIMARY KEY CLUSTERED 
(
	[tagid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[subscriptions]    Script Date: 09/27/2007 23:47:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[subscriptions](
	[subscriptionid] [uniqueidentifier] NOT NULL,
	[userid] [uniqueidentifier] NOT NULL,
	[itemid] [uniqueidentifier] NOT NULL,
	[notify] [bit] NULL CONSTRAINT [DF_subscriptions_notify]  DEFAULT ((0)),
	[archived] [bit] NULL CONSTRAINT [DF_subscriptions_archived]  DEFAULT ((0)),
	[iv_subscriptiontype] [int] NULL CONSTRAINT [DF_subscriptions_subscriptiontype]  DEFAULT ((0)),
 CONSTRAINT [PK_subscriptions] PRIMARY KEY CLUSTERED 
(
	[subscriptionid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[email]    Script Date: 09/27/2007 23:45:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[email](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[pageid] [uniqueidentifier] NOT NULL,
	[senderid] [nvarchar](50) NOT NULL,
	[recipientid] [nvarchar](50) NOT NULL,
	[msgid] [int] NOT NULL,
	[iv_status] [int] NOT NULL,
	[createdate] [datetime] NOT NULL CONSTRAINT [DF_email_createdate]  DEFAULT (getdate()),
	[archived] [bit] NULL CONSTRAINT [DF_email_archived]  DEFAULT ((0)),
 CONSTRAINT [PK_email] PRIMARY KEY CLUSTERED 
(
	[pageid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[suggestion]    Script Date: 09/27/2007 23:47:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[suggestion](
	[suggestionid] [uniqueidentifier] NOT NULL,
	[createdate] [datetime] NOT NULL CONSTRAINT [DF_article_suggestion_createdate]  DEFAULT (getdate()),
	[suggestdesc] [varchar](max) NOT NULL,
	[suggestedbyemail] [varchar](max) NOT NULL CONSTRAINT [DF_article_suggestion_suggestedbyemail]  DEFAULT ('NA'),
	[iv_itemtype] [int] NOT NULL CONSTRAINT [DF_suggestion_iv_itemtype]  DEFAULT ((2)),
	[archived] [bit] NULL CONSTRAINT [DF_suggestion_archived]  DEFAULT ((0)),
 CONSTRAINT [PK_article_suggestion] PRIMARY KEY CLUSTERED 
(
	[suggestionid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[private_message]    Script Date: 09/27/2007 23:47:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[private_message](
	[PrivateMessageID] [uniqueidentifier] NOT NULL,
	[FromUserID] [uniqueidentifier] NOT NULL,
	[Subject] [nvarchar](max) NOT NULL,
	[Body] [nvarchar](max) NOT NULL,
	[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_private_message_CreateDate]  DEFAULT (getdate()),
	[archived] [bit] NULL CONSTRAINT [DF_private_message_archived]  DEFAULT ((0)),
 CONSTRAINT [PK_private_message] PRIMARY KEY CLUSTERED 
(
	[PrivateMessageID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[forum_forum]    Script Date: 09/27/2007 23:45:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[forum_forum](
	[ForumID] [uniqueidentifier] NOT NULL,
	[CategoryID] [uniqueidentifier] NOT NULL,
	[ForumName] [nvarchar](max) NOT NULL,
	[Description] [nvarchar](max) NOT NULL,
	[SortOrder] [int] NOT NULL,
	[TopicsCount] [int] NULL,
	[PostsCount] [int] NULL,
	[LastPostBy] [nvarchar](max) NULL,
	[LastUserID] [uniqueidentifier] NULL,
	[LastPostDate] [datetime] NULL,
	[Locked] [bit] NULL,
    [Moderated] [bit] NULL,
 CONSTRAINT [PK_forum_forum] PRIMARY KEY CLUSTERED 
(
	[ForumID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[forum_post]    Script Date: 09/27/2007 23:46:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[forum_post](
	[PostID] [uniqueidentifier] NOT NULL,
	[TopicID] [uniqueidentifier] NOT NULL,
	[RepliedTo] [uniqueidentifier] NULL,
	[UserID] [uniqueidentifier] NOT NULL,
	[Created] [datetime] NOT NULL,
	[Post] [varchar](max) NOT NULL,
	[Edited] [datetime] NULL,
	[IsApproved] [bit] NULL,
 CONSTRAINT [PK_forum_post] PRIMARY KEY CLUSTERED 
(
	[PostID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[item_resources]    Script Date: 09/27/2007 23:46:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[item_resources](
	[itemid] [uniqueidentifier] NOT NULL,
	[resourceid] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[security]    Script Date: 09/27/2007 23:47:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[security](
	[id] [uniqueidentifier] NOT NULL,
	[secureitemid] [uniqueidentifier] NOT NULL,
	[rolename] [nvarchar](256) NOT NULL,
 CONSTRAINT [PK_security] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[user_private_message]    Script Date: 09/27/2007 23:47:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[user_private_message](
	[UserPrivateMessageID] [uniqueidentifier] NOT NULL,
	[UserID] [uniqueidentifier] NOT NULL,
	[PrivateMessageID] [uniqueidentifier] NOT NULL,
	[IsViewed] [bit] NULL CONSTRAINT [DF_user_private_message_IsViewed]  DEFAULT ((0)),
 CONSTRAINT [PK_user_private_message] PRIMARY KEY CLUSTERED 
(
	[UserPrivateMessageID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[page_suggestion]    Script Date: 09/27/2007 23:46:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[page_suggestion](
	[pageid] [uniqueidentifier] NOT NULL,
	[suggestionid] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[properties]    Script Date: 09/27/2007 23:47:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[properties](
	[propertyid] [uniqueidentifier] NOT NULL,
	[parentpropertyid] [uniqueidentifier] NULL,
	[name] [varchar](max) NOT NULL,
	[createdate] [datetime] NOT NULL,
	[archived] [tinyint] NULL CONSTRAINT [DF_properties_archived]  DEFAULT ((0)),
 CONSTRAINT [PK_properties] PRIMARY KEY CLUSTERED 
(
	[propertyid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[news]    Script Date: 09/27/2007 23:46:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[news](
	[newsid] [uniqueidentifier] NOT NULL,
	[title] [nvarchar](max) NULL,
	[body] [nvarchar](max) NOT NULL,
	[createdate] [datetime] NOT NULL CONSTRAINT [DF_news_createdate]  DEFAULT (getdate()),
	[expiredate] [datetime] NULL,
	[archived] [bit] NULL CONSTRAINT [DF_news_archived]  DEFAULT ((0)),
	[sticky] [bit] NULL CONSTRAINT [DF_news_sticky]  DEFAULT ((0)),
	[userid] [uniqueidentifier] NULL,
 CONSTRAINT [PK_news] PRIMARY KEY CLUSTERED 
(
	[newsid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[forum_topic]    Script Date: 09/27/2007 23:46:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[forum_topic](
	[TopicID] [uniqueidentifier] NOT NULL,
	[ForumID] [uniqueidentifier] NOT NULL,
	[TopicName] [nvarchar](max) NOT NULL,
	[UserID] [uniqueidentifier] NOT NULL,
	[Created] [datetime] NOT NULL,
	[Views] [int] NULL,
	[PostsCount] [int] NULL,
	[LastPostBy] [nvarchar](max) NULL,
	[LastUserID] [uniqueidentifier] NULL,
	[LastPostDate] [datetime] NULL,
	[Sticky] [bit] NULL,
	[IsApproved] [bit] NULL,
 CONSTRAINT [PK_forum_topic] PRIMARY KEY CLUSTERED 
(
	[TopicID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[item_properties]    Script Date: 09/27/2007 23:46:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[item_properties](
	[itemid] [uniqueidentifier] NOT NULL,
	[propertyid] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[template_header]    Script Date: 09/27/2007 23:47:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[template_header](
	[templateid] [uniqueidentifier] NOT NULL CONSTRAINT [DF_template_header_templateid]  DEFAULT (newid()),
	[templatename] [nvarchar](500) NOT NULL,
	[numberofplaceholders] [int] NOT NULL CONSTRAINT [DF_template_header_numberofplaceholders]  DEFAULT ((0)),
	[archived] [bit] NULL CONSTRAINT [DF_template_header_archived]  DEFAULT ((0)),
 CONSTRAINT [PK_template_header] PRIMARY KEY CLUSTERED 
(
	[templateid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[forum_category]    Script Date: 09/27/2007 23:45:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[forum_category](
	[CategoryID] [uniqueidentifier] NOT NULL,
	[BoardID] [uniqueidentifier] NOT NULL,
	[CategoryName] [nvarchar](500) NOT NULL,
	[SortOrder] [int] NOT NULL,
	[LastPostBy] [nvarchar](max) NULL,
	[LastUserID] [uniqueidentifier] NULL,
	[LastPostDate] [datetime] NULL,
 CONSTRAINT [PK_forum_category] PRIMARY KEY CLUSTERED 
(
	[CategoryID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[aspnet_WebEvent_Events]    Script Date: 09/27/2007 23:45:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[aspnet_WebEvent_Events](
	[EventId] [char](32) NOT NULL,
	[EventTimeUtc] [datetime] NOT NULL,
	[EventTime] [datetime] NOT NULL,
	[EventType] [nvarchar](256) NOT NULL,
	[EventSequence] [decimal](19, 0) NOT NULL,
	[EventOccurrence] [decimal](19, 0) NOT NULL,
	[EventCode] [int] NOT NULL,
	[EventDetailCode] [int] NOT NULL,
	[Message] [nvarchar](1024) NULL,
	[ApplicationPath] [nvarchar](256) NULL,
	[ApplicationVirtualPath] [nvarchar](256) NULL,
	[MachineName] [nvarchar](256) NOT NULL,
	[RequestUrl] [nvarchar](1024) NULL,
	[ExceptionType] [nvarchar](256) NULL,
	[Details] [ntext] NULL,
PRIMARY KEY CLUSTERED 
(
	[EventId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[events]    Script Date: 09/27/2007 23:45:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[events](
	[EventID] [uniqueidentifier] NOT NULL,
	[EventTitle] [nvarchar](max) NOT NULL,
	[EventDetails] [nvarchar](max) NOT NULL,
	[EventDate] [datetime] NOT NULL,
	[UserID] [uniqueidentifier] NOT NULL,
	[StartDate] [datetime] NULL,
	[EndDate] [datetime] NULL,
	[Day] [int] NULL CONSTRAINT [DF_events_day]  DEFAULT ((0)),
	[Month] [int] NULL CONSTRAINT [DF_events_month]  DEFAULT ((0)),
	[Year] [int] NULL CONSTRAINT [DF_events_year]  DEFAULT ((0)),
	[Hr] [int] NULL CONSTRAINT [DF_events_hr]  DEFAULT ((0)),
	[Min] [int] NULL CONSTRAINT [DF_events_min]  DEFAULT ((0)),
	[Meridian] [nvarchar](2) NULL,
	[Occurenceid] [uniqueidentifier] NULL,
	[Private] [bit] NULL CONSTRAINT [DF_events_private]  DEFAULT ((0)),
 CONSTRAINT [PK_events] PRIMARY KEY CLUSTERED 
(
	[EventID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[aspnet_PersonalizationAllUsers]    Script Date: 09/27/2007 23:44:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aspnet_PersonalizationAllUsers](
	[PathId] [uniqueidentifier] NOT NULL,
	[PageSettings] [image] NOT NULL,
	[LastUpdatedDate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[PathId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[aspnet_PersonalizationPerUser]    Script Date: 09/27/2007 23:44:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aspnet_PersonalizationPerUser](
	[Id] [uniqueidentifier] NOT NULL DEFAULT (newid()),
	[PathId] [uniqueidentifier] NULL,
	[UserId] [uniqueidentifier] NULL,
	[PageSettings] [image] NOT NULL,
	[LastUpdatedDate] [datetime] NOT NULL,
PRIMARY KEY NONCLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[aspnet_UsersInRoles]    Script Date: 09/27/2007 23:45:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aspnet_UsersInRoles](
	[UserId] [uniqueidentifier] NOT NULL,
	[RoleId] [uniqueidentifier] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserId] ASC,
	[RoleId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[aspnet_Profile]    Script Date: 09/27/2007 23:44:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aspnet_Profile](
	[UserId] [uniqueidentifier] NOT NULL,
	[PropertyNames] [ntext] NOT NULL,
	[PropertyValuesString] [ntext] NOT NULL,
	[PropertyValuesBinary] [image] NOT NULL,
	[LastUpdatedDate] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[UserId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[aspnet_Membership]    Script Date: 09/27/2007 23:44:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aspnet_Membership](
	[ApplicationId] [uniqueidentifier] NOT NULL,
	[UserId] [uniqueidentifier] NOT NULL,
	[Password] [nvarchar](128) NOT NULL,
	[PasswordFormat] [int] NOT NULL DEFAULT ((0)),
	[PasswordSalt] [nvarchar](128) NOT NULL,
	[MobilePIN] [nvarchar](16) NULL,
	[Email] [nvarchar](256) NULL,
	[LoweredEmail] [nvarchar](256) NULL,
	[PasswordQuestion] [nvarchar](256) NULL,
	[PasswordAnswer] [nvarchar](128) NULL,
	[IsApproved] [bit] NOT NULL,
	[IsLockedOut] [bit] NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[LastLoginDate] [datetime] NOT NULL,
	[LastPasswordChangedDate] [datetime] NOT NULL,
	[LastLockoutDate] [datetime] NOT NULL,
	[FailedPasswordAttemptCount] [int] NOT NULL,
	[FailedPasswordAttemptWindowStart] [datetime] NOT NULL,
	[FailedPasswordAnswerAttemptCount] [int] NOT NULL,
	[FailedPasswordAnswerAttemptWindowStart] [datetime] NOT NULL,
	[Comment] [ntext] NULL,
PRIMARY KEY NONCLUSTERED 
(
	[UserId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[aspnet_Users]    Script Date: 09/27/2007 23:45:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aspnet_Users](
	[ApplicationId] [uniqueidentifier] NOT NULL,
	[UserId] [uniqueidentifier] NOT NULL DEFAULT (newid()),
	[UserName] [nvarchar](256) NOT NULL,
	[LoweredUserName] [nvarchar](256) NOT NULL,
	[MobileAlias] [nvarchar](16) NULL DEFAULT (NULL),
	[IsAnonymous] [bit] NOT NULL DEFAULT ((0)),
	[LastActivityDate] [datetime] NOT NULL,
PRIMARY KEY NONCLUSTERED 
(
	[UserId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[aspnet_Roles]    Script Date: 09/27/2007 23:44:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aspnet_Roles](
	[ApplicationId] [uniqueidentifier] NOT NULL,
	[RoleId] [uniqueidentifier] NOT NULL DEFAULT (newid()),
	[RoleName] [nvarchar](256) NOT NULL,
	[LoweredRoleName] [nvarchar](256) NOT NULL,
	[Description] [nvarchar](256) NULL,
PRIMARY KEY NONCLUSTERED 
(
	[RoleId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[aspnet_Paths]    Script Date: 09/27/2007 23:44:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[aspnet_Paths](
	[ApplicationId] [uniqueidentifier] NOT NULL,
	[PathId] [uniqueidentifier] NOT NULL DEFAULT (newid()),
	[Path] [nvarchar](256) NOT NULL,
	[LoweredPath] [nvarchar](256) NOT NULL,
PRIMARY KEY NONCLUSTERED 
(
	[PathId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[page]    Script Date: 09/27/2007 23:46:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[page](
	[pageid] [uniqueidentifier] NOT NULL,
	[kbid] [int] IDENTITY(1,1) NOT NULL,
	[createdate] [datetime] NOT NULL CONSTRAINT [DF_article_createdate]  DEFAULT (getdate()),
	[publishdate] [datetime] NULL,
	[expiredate] [datetime] NULL,
	[statusdate] [datetime] NULL CONSTRAINT [DF_article_statusdate]  DEFAULT (getdate()),
	[currentuserid] [uniqueidentifier] NULL,
	[title] [varchar](max) NOT NULL,
	[iv_access_type] [int] NOT NULL CONSTRAINT [DF_article_iv_access_type]  DEFAULT ((0)),
	[iv_level] [int] NOT NULL CONSTRAINT [DF_article_iv_level]  DEFAULT ((0)),
	[iv_status] [int] NOT NULL CONSTRAINT [DF_article_iv_status]  DEFAULT ((0)),
	[iv_priority] [int] NOT NULL CONSTRAINT [DF_article_iv_priority]  DEFAULT ((0)),
	[templateid] [uniqueidentifier] NOT NULL,
	[keywords] [varchar](max) NOT NULL CONSTRAINT [DF_article_keywords]  DEFAULT (N'No Keywords Defined'),
	[pagerevision] [int] NULL CONSTRAINT [DF_article_articlerevision]  DEFAULT ((0)),
	[iv_itemtype] [int] NOT NULL CONSTRAINT [DF_article_iv_itemtype]  DEFAULT ((1)),
	[spotlight] [bit] NULL CONSTRAINT [DF_page_spotlight]  DEFAULT ((0)),
	[userid] [uniqueidentifier] NULL,
 CONSTRAINT [PK_article] PRIMARY KEY CLUSTERED 
(
	[pageid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  ForeignKey [FK__aspnet_Me__Appli__29221CFB]    Script Date: 09/27/2007 23:44:46 ******/
ALTER TABLE [dbo].[aspnet_Membership]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Me__Appli__29221CFB] FOREIGN KEY([ApplicationId])
REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
GO
ALTER TABLE [dbo].[aspnet_Membership] CHECK CONSTRAINT [FK__aspnet_Me__Appli__29221CFB]
GO
/****** Object:  ForeignKey [FK__aspnet_Me__UserI__2A164134]    Script Date: 09/27/2007 23:44:46 ******/
ALTER TABLE [dbo].[aspnet_Membership]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Me__UserI__2A164134] FOREIGN KEY([UserId])
REFERENCES [dbo].[aspnet_Users] ([UserId])
GO
ALTER TABLE [dbo].[aspnet_Membership] CHECK CONSTRAINT [FK__aspnet_Me__UserI__2A164134]
GO
/****** Object:  ForeignKey [FK__aspnet_Pa__Appli__2B0A656D]    Script Date: 09/27/2007 23:44:49 ******/
ALTER TABLE [dbo].[aspnet_Paths]  WITH CHECK ADD FOREIGN KEY([ApplicationId])
REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__2739D489]    Script Date: 09/27/2007 23:44:50 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers]  WITH CHECK ADD FOREIGN KEY([PathId])
REFERENCES [dbo].[aspnet_Paths] ([PathId])
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__PathI__25518C17]    Script Date: 09/27/2007 23:44:53 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser]  WITH CHECK ADD FOREIGN KEY([PathId])
REFERENCES [dbo].[aspnet_Paths] ([PathId])
GO
/****** Object:  ForeignKey [FK__aspnet_Pe__UserI__2645B050]    Script Date: 09/27/2007 23:44:54 ******/
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser]  WITH CHECK ADD FOREIGN KEY([UserId])
REFERENCES [dbo].[aspnet_Users] ([UserId])
GO
/****** Object:  ForeignKey [FK__aspnet_Pr__UserI__2FCF1A8A]    Script Date: 09/27/2007 23:44:56 ******/
ALTER TABLE [dbo].[aspnet_Profile]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Pr__UserI__2FCF1A8A] FOREIGN KEY([UserId])
REFERENCES [dbo].[aspnet_Users] ([UserId])
GO
ALTER TABLE [dbo].[aspnet_Profile] CHECK CONSTRAINT [FK__aspnet_Pr__UserI__2FCF1A8A]
GO
/****** Object:  ForeignKey [FK__aspnet_Ro__Appli__2BFE89A6]    Script Date: 09/27/2007 23:45:00 ******/
ALTER TABLE [dbo].[aspnet_Roles]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Ro__Appli__2BFE89A6] FOREIGN KEY([ApplicationId])
REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
GO
ALTER TABLE [dbo].[aspnet_Roles] CHECK CONSTRAINT [FK__aspnet_Ro__Appli__2BFE89A6]
GO
/****** Object:  ForeignKey [FK__aspnet_Us__Appli__2CF2ADDF]    Script Date: 09/27/2007 23:45:08 ******/
ALTER TABLE [dbo].[aspnet_Users]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Us__Appli__2CF2ADDF] FOREIGN KEY([ApplicationId])
REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
GO
ALTER TABLE [dbo].[aspnet_Users] CHECK CONSTRAINT [FK__aspnet_Us__Appli__2CF2ADDF]
GO
/****** Object:  ForeignKey [FK__aspnet_Us__RoleI__2DE6D218]    Script Date: 09/27/2007 23:45:09 ******/
ALTER TABLE [dbo].[aspnet_UsersInRoles]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Us__RoleI__2DE6D218] FOREIGN KEY([RoleId])
REFERENCES [dbo].[aspnet_Roles] ([RoleId])
GO
ALTER TABLE [dbo].[aspnet_UsersInRoles] CHECK CONSTRAINT [FK__aspnet_Us__RoleI__2DE6D218]
GO
/****** Object:  ForeignKey [FK__aspnet_Us__UserI__2EDAF651]    Script Date: 09/27/2007 23:45:10 ******/
ALTER TABLE [dbo].[aspnet_UsersInRoles]  WITH CHECK ADD  CONSTRAINT [FK__aspnet_Us__UserI__2EDAF651] FOREIGN KEY([UserId])
REFERENCES [dbo].[aspnet_Users] ([UserId])
GO
ALTER TABLE [dbo].[aspnet_UsersInRoles] CHECK CONSTRAINT [FK__aspnet_Us__UserI__2EDAF651]
GO
/****** Object:  ForeignKey [FK_article_email]    Script Date: 09/27/2007 23:46:34 ******/
ALTER TABLE [dbo].[page]  WITH NOCHECK ADD  CONSTRAINT [FK_article_email] FOREIGN KEY([pageid])
REFERENCES [dbo].[email] ([pageid])
NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[page] NOCHECK CONSTRAINT [FK_article_email]
GO
